using Microsoft.EntityFrameworkCore.Migrations;

namespace YoYoMooc.StudentManagement.Services.Migrations
{
    public partial class spGetStudentById_procedure : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            var procedure = @"Create Procedure spGetStudentById
                                @Id int
                                as
                                Begin
                                 Select * from Students
                                 Where Id = @Id
                                End";             

            migrationBuilder.Sql(procedure);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {

            string procedure = @"Drop procedure spGetStudentById";
            migrationBuilder.Sql(procedure);

        }
    }
}